History of db-benchmark timings

Work in progress: performance regression tracking

Note:

• missing LastRun is likely to occur when no runs happened for more than a week, so the values would be the same as LastWeek.
• missing summary values are likely to occur due to the missing timing values, for example, due to the performance regression a question haven’t finished, then we should not skip it during calculating mean. As a result there might be not much to show.
• entries that are constantly missing are removed (like not yet implemented, or pandas 1e9).
• first run timings are used in calculations.
• timing metrics are not normalized when passing to mean, thus mean over data sizes (1e7, 1e8, 1e9) will do something like mean(c(0.1, 1, 10)). As a result mean over time is not matching mean over percent metrics.

Solution

data.table

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	3.3			3.2	3%	3.2	7%	3.4	-3%
2	4.3			4.5	-27%	4.4	-4%	4.6	-3%
3	5.9			5.7	2%	5.3	6%	4.9	4%
4	6.1			5.7	3%	6.0	2%	5.8	-4%
5	5.7			5.7	6%	7.2	-8%	5.1	-2%
6	46.4			52.8	-1%	51.1	1%
7	37.0			38.0	0%	39.7	-1%
8	82.1			86.4	-3%	88.1	-2%
9	16.7			15.9	7%	16.7	8%	25.0	-14%
10	67.9			75.0	-2%	72.2	0%	66.4	0%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	0.6			0.7	0%	0.6	7%
1e8	6.2			6.4	-2%	6.2	0%
1e9	75.8			80.8	-1%	81.4	-3%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	27.6			29.3	-1%	29.4	1%
1e1	95.6			93.2	1%	92.1	0%
2e0	61.1			60.4	0%	61.1	0%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	27.6			29.3	-1%	29.4	1%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	27.6			29.3	-1%	29.4	1%
1	23.0			23.4	4%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.1			0.1	8%	0.1	16%	0.1	-7%
1	1e8	0.9			0.9	-1%	0.9	3%	1.0	-2%
1	1e9	8.9			8.7	2%	8.7	3%	9.0	0%
2	1e7	0.1			0.6	-83%	0.1	-12%	0.1	0%
2	1e8	1.0			1.0	0%	1.0	0%	1.0	-3%
2	1e9	11.9			11.9	0%	12.0	0%	12.7	-5%
3	1e7	0.1			0.1	7%	0.1	10%	0.1	0%
3	1e8	1.3			1.3	-2%	1.3	0%	1.4	-7%
3	1e9	16.2			15.7	3%	14.6	11%	13.2	23%
4	1e7	0.2			0.2	10%	0.2	14%	0.3	-17%
4	1e8	1.5			1.6	-6%	1.7	-10%	1.5	0%
4	1e9	16.6			15.3	8%	16.0	3%	15.7	5%
5	1e7	0.2			0.1	21%	0.2	13%	0.2	-11%
5	1e8	1.5			1.5	-1%	1.7	-16%	1.6	-9%
5	1e9	15.3			15.6	-1%	19.7	-22%	13.6	13%
6	1e7	1.1			1.1	8%	1.0	14%
6	1e8	11.7			11.5	1%	11.7	0%
6	1e9	126.4			145.7	-13%	140.5	-10%
7	1e7	0.6			0.6	2%	0.6	3%
7	1e8	7.2			7.3	-2%	7.2	0%
7	1e9	103.2			105.9	-2%	111.4	-7%
8	1e7	1.5			1.4	1%	1.4	0%
8	1e8	16.3			17.7	-7%	16.5	-1%
8	1e9	228.6			240.0	-4%	246.5	-7%
9	1e7	0.9			0.8	19%	0.8	15%	0.7	24%
9	1e8	3.7			3.8	-2%	3.3	11%	5.7	-33%
9	1e9	45.6			43.1	5%	45.9	0%	68.6	-33%
10	1e7	1.6			1.5	5%	1.6	1%	1.7	-4%
10	1e8	17.3			17.6	-1%	16.8	2%	16.4	5%
10	1e9	184.9			205.8	-10%	198.2	-6%	181.2	2%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	3.3			3.2	3%	3.2	7%	3.4	-3%
1	1e1	4.3			4.0	12%	4.3	4%	4.2	8%
1	2e0	5.2			4.9	3%	4.9	0%	4.8	3%
2	1e2	4.3			4.5	-27%	4.4	-4%	4.6	-3%
2	1e1	5.5			5.2	0%	6.3	-5%	5.8	-11%
2	2e0	6.3			6.0	10%	5.9	6%	5.5	20%
3	1e2	5.9			5.7	2%	5.3	6%	4.9	4%
3	1e1	11.1			11.0	-1%	10.8	-1%	10.5	-17%
3	2e0	214.4			212.8	0%	215.6	-5%
4	1e2	6.1			5.7	3%	6.0	2%	5.8	-4%
4	1e1	8.3			7.9	3%	7.6	8%	7.7	6%
4	2e0	1.4			1.3	2%	1.3	-2%	1.3	0%
5	1e2	5.7			5.7	6%	7.2	-8%	5.1	-2%
5	1e1	11.7			12.3	-2%	12.3	-4%	12.0	-15%
5	2e0	3.8			3.8	-7%	3.6	-2%	3.7	-12%
6	1e2	46.4			52.8	-1%	51.1	1%
6	1e1	37.5			36.3	0%	39.1	-3%
6	2e0	2.7			2.9	-2%	3.0	-8%
7	1e2	37.0			38.0	0%	39.7	-1%
7	1e1	161.6			154.5	1%	151.6	2%
7	2e0	64.6			65.6	-1%	65.9	0%
8	1e2	82.1			86.4	-3%	88.1	-2%
8	1e1	583.6			567.5	0%	556.0	1%
8	2e0	279.4			273.5	0%	278.2	0%
9	1e2	16.7			15.9	7%	16.7	8%	25.0	-14%
9	1e1	12.2			12.0	0%	12.0	-1%	18.5	-29%
9	2e0	1.5			1.5	-5%	1.5	6%	1.8	-9%
10	1e2	67.9			75.0	-2%	72.2	0%	66.4	0%
10	1e1	120.7			120.9	2%	120.7	0%	120.6	3%
10	2e0	10.0			10.2	-4%	9.8	2%	11.8	-34%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	0.6			0.7	0%	0.6	7%
1e2	1e8	6.2			6.4	-2%	6.2	0%
1e2	1e9	75.8			80.8	-1%	81.4	-3%
1e1	1e7	1.8			1.8	4%	1.8	0%
1e1	1e8	21.3			22.3	-3%	21.4	-1%
1e1	1e9	263.8			255.4	3%	253.1	0%
2e0	1e7	8.0			8.2	-2%	7.9	-2%
2e0	1e8	68.2			67.0	0%	68.3	0%
2e0	1e9	214.5			212.4	5%	214.4	5%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	3.3			3.2	3%	3.2	7%	3.4	-3%
1e2	2	4.3			4.5	-27%	4.4	-4%	4.6	-3%
1e2	3	5.9			5.7	2%	5.3	6%	4.9	4%
1e2	4	6.1			5.7	3%	6.0	2%	5.8	-4%
1e2	5	5.7			5.7	6%	7.2	-8%	5.1	-2%
1e2	6	46.4			52.8	-1%	51.1	1%
1e2	7	37.0			38.0	0%	39.7	-1%
1e2	8	82.1			86.4	-3%	88.1	-2%
1e2	9	16.7			15.9	7%	16.7	8%	25.0	-14%
1e2	10	67.9			75.0	-2%	72.2	0%	66.4	0%
1e1	1	4.3			4.0	12%	4.3	4%	4.2	8%
1e1	2	5.5			5.2	0%	6.3	-5%	5.8	-11%
1e1	3	11.1			11.0	-1%	10.8	-1%	10.5	-17%
1e1	4	8.3			7.9	3%	7.6	8%	7.7	6%
1e1	5	11.7			12.3	-2%	12.3	-4%	12.0	-15%
1e1	6	37.5			36.3	0%	39.1	-3%
1e1	7	161.6			154.5	1%	151.6	2%
1e1	8	583.6			567.5	0%	556.0	1%
1e1	9	12.2			12.0	0%	12.0	-1%	18.5	-29%
1e1	10	120.7			120.9	2%	120.7	0%	120.6	3%
2e0	1	5.2			4.9	3%	4.9	0%	4.8	3%
2e0	2	6.3			6.0	10%	5.9	6%	5.5	20%
2e0	3	214.4			212.8	0%	215.6	-5%
2e0	4	1.4			1.3	2%	1.3	-2%	1.3	0%
2e0	5	3.8			3.8	-7%	3.6	-2%	3.7	-12%
2e0	6	2.7			2.9	-2%	3.0	-8%
2e0	7	64.6			65.6	-1%	65.9	0%
2e0	8	279.4			273.5	0%	278.2	0%
2e0	9	1.5			1.5	-5%	1.5	6%	1.8	-9%
2e0	10	10.0			10.2	-4%	9.8	2%	11.8	-34%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.6			0.7	0%	0.6	7%
0	1e8	6.2			6.4	-2%	6.2	0%
0	1e9	75.8			80.8	-1%	81.4	-3%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.6			0.7	0%	0.6	7%
0	1e8	6.2			6.4	-2%	6.2	0%
0	1e9	75.8			80.8	-1%	81.4	-3%
1	1e7	0.5			0.5	-1%	0.5	0%
1	1e8	5.1			5.0	4%	5.3	0%
1	1e9	63.4			64.7	12%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	2.4			2.5	-11%	2.5	-4%
2	2.0			2.2	-4%	2.0	0%
3	4.3			4.3	0%	4.2	2%
4	2.0			2.1	-2%	2.0	2%
5	13.8			13.9	7%	13.4	10%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	0.9			0.9	0%	0.8	4%
1e8	8.9			9.2	-4%	8.8	0%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	4.9			5.0	-2%	4.8	2%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	4.9			5.0	-2%	4.8	2%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.3			0.4	-21%	0.3	-6%
1	1e8	4.6			4.7	-2%	4.7	-2%
2	1e7	0.4			0.4	1%	0.4	0%
2	1e8	3.7			4.1	-10%	3.6	0%
3	1e7	0.7			0.7	2%	0.7	2%
3	1e8	7.8			8.0	-2%	7.7	1%
4	1e7	0.3			0.3	2%	0.3	4%
4	1e8	3.6			4.0	-7%	3.7	0%
5	1e7	2.9			2.5	17%	2.4	20%
5	1e8	24.6			25.4	-3%	24.4	1%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.9			0.9	0%	0.8	4%
0	1e8	8.9			9.2	-4%	8.8	0%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.9			0.9	0%	0.8	4%
0	1e8	8.9			9.2	-4%	8.8	0%

dplyr

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1								8.3
2								24.0
3								88.0
4								32.5
5								192.9
6	7.2			7.3	1%	7.4	0%
7	13.2			13.2	2%	13.2	2%
8	28.1			28.4	0%	28.7	-1%
9								50.4
10	897.2			1010.8	-7%	1045.7	-8%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	17.1			17.6	-3%	17.4	0%
1e8	181.8			204.3	-3%	211.4	-3%
1e9								183.4

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2
1e1
2e0	142.2			146.0	-2%	144.2	0%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0
1

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.3			0.4	-18%	0.3	-1%	0.3	26%
1	1e8	3.3			3.5	-6%	3.4	-2%	2.2	51%
1	1e9								22.6
2	1e7	0.8			0.9	-5%	0.9	-5%	0.5	65%
2	1e8	9.1			9.3	-2%	9.4	-3%	6.3	44%
2	1e9								65.1
3	1e7	1.8			1.9	-3%	1.7	2%	0.7	138%
3	1e8	30.3			30.6	0%	30.5	0%	16.6	82%
3	1e9								246.5
4	1e7	0.5			0.6	-7%	0.5	-2%	0.6	-7%
4	1e8	6.0			6.6	-9%	6.2	-4%	8.2	-27%
4	1e9								88.7
5	1e7	1.5			1.5	-2%	1.5	0%	1.5	-2%
5	1e8	30.9			31.6	-2%	30.7	0%	38.4	-19%
5	1e9								538.8
6	1e7	1.6			1.6	4%	1.6	4%
6	1e8	12.8			13.0	-2%	13.2	-3%
7	1e7	1.1			1.1	4%	1.1	5%
7	1e8	25.2			25.3	0%	25.4	0%
8	1e7	3.8			3.9	0%	3.9	-1%
8	1e8	52.4			53.0	-1%	53.4	-1%
9	1e7	1.3			1.3	0%	1.4	-6%	1.3	-2%
9	1e8	11.5			11.4	1%	11.6	0%	10.8	7%
9	1e9								139.0
10	1e7	158.3			163.1	-2%	161.1	-1%
10	1e8	1636.1			1858.5	-11%	1930.4	-15%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2								8.3
1	1e1	10.3			10.5	2%	10.4	-1%	6.3	100%
1	2e0	7.9			8.8	-4%	8.4	-3%	4.5	92%
2	1e2								24.0
2	1e1								11.0
2	2e0	12.7			12.2	0%	12.4	0%	7.6	78%
3	1e2								88.0
3	1e1								173.4
3	2e0	272.4			282.2	-3%	274.0	-1%	40.3	577%
4	1e2								32.5
4	1e1								19.2
4	2e0	1.6			1.8	0%	1.4	14%	1.6	5%
5	1e2								192.9
5	1e1								472.9
5	2e0	293.7			302.8	-3%	300.0	-1%	85.7	223%
6	1e2	7.2			7.3	1%	7.4	0%
6	1e1	3.9			3.8	3%	4.1	-3%
6	2e0	3.2			3.5	-6%	3.4	0%
7	1e2	13.2			13.2	2%	13.2	2%
7	1e1	51.6			49.6	1%	50.8	1%
7	2e0	188.7			194.4	-2%	187.8	2%
8	1e2	28.1			28.4	0%	28.7	-1%
8	1e1	148.2			161.5	-5%	166.5	-6%
8	2e0	608.5			618.1	-3%	620.0	-2%
9	1e2								50.4
9	1e1	3.7			3.7	5%	3.8	2%	3.2	21%
9	2e0	2.7			2.9	-3%	2.5	4%	2.0	28%
10	1e2	897.2			1010.8	-7%	1045.7	-8%
10	1e1	1098.2			1008.2	3%	1087.0	0%
10	2e0	181.3			191.0	-5%	187.8	-3%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	17.1			17.6	-3%	17.4	0%
1e2	1e8	181.8			204.3	-3%	211.4	-3%
1e2	1e9								183.4
1e1	1e7	22.2			22.8	0%	22.7	-1%
1e1	1e8	271.1			253.0	4%	271.0	0%
1e1	1e9								381.7
2e0	1e7	39.9			41.7	-2%	40.9	1%
2e0	1e8	281.2			288.0	-3%	284.9	0%
2e0	1e9	27.7			28.3	-3%	28.0	-1%	16.4	70%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1								8.3
1e2	2								24.0
1e2	3								88.0
1e2	4								32.5
1e2	5								192.9
1e2	6	7.2			7.3	1%	7.4	0%
1e2	7	13.2			13.2	2%	13.2	2%
1e2	8	28.1			28.4	0%	28.7	-1%
1e2	9								50.4
1e2	10	897.2			1010.8	-7%	1045.7	-8%
1e1	1	10.3			10.5	2%	10.4	-1%	6.3	100%
1e1	2								11.0
1e1	3								173.4
1e1	4								19.2
1e1	5								472.9
1e1	6	3.9			3.8	3%	4.1	-3%
1e1	7	51.6			49.6	1%	50.8	1%
1e1	8	148.2			161.5	-5%	166.5	-6%
1e1	9	3.7			3.7	5%	3.8	2%	3.2	21%
1e1	10	1098.2			1008.2	3%	1087.0	0%
2e0	1	7.9			8.8	-4%	8.4	-3%	4.5	92%
2e0	2	12.7			12.2	0%	12.4	0%	7.6	78%
2e0	3	272.4			282.2	-3%	274.0	-1%	40.3	577%
2e0	4	1.6			1.8	0%	1.4	14%	1.6	5%
2e0	5	293.7			302.8	-3%	300.0	-1%	85.7	223%
2e0	6	3.2			3.5	-6%	3.4	0%
2e0	7	188.7			194.4	-2%	187.8	2%
2e0	8	608.5			618.1	-3%	620.0	-2%
2e0	9	2.7			2.9	-3%	2.5	4%	2.0	28%
2e0	10	181.3			191.0	-5%	187.8	-3%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	17.1			17.6	-3%	17.4	0%
0	1e8	181.8			204.3	-3%	211.4	-3%
0	1e9								183.4

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	17.1			17.6	-3%	17.4	0%
0	1e8	181.8			204.3	-3%	211.4	-3%
0	1e9								183.4
1	1e7	15.0			15.0	-3%	15.7	-3%
1	1e8	167.2			169.6	0%	177.3	-3%
1	1e9								149.2

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	9.0			9.0	1%	9.1	1%
2	8.5			8.3	-1%	8.2	4%
3	10.1			10.0	0%	10.0	0%
4	8.8			8.6	3%	8.8	0%
5	93.6			92.5	1%	93.6	0%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	3.7			3.6	0%	3.6	1%
1e8	48.4			47.7	1%	48.3	0%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	26.0			25.7	1%	25.9	1%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	26.0			25.7	1%	25.9	1%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	1.6			1.5	1%	1.5	3%
1	1e8	16.5			16.4	0%	16.7	0%
2	1e7	1.3			1.4	-7%	1.2	4%
2	1e8	15.8			15.1	4%	15.2	3%
3	1e7	1.5			1.5	0%	1.5	0%
3	1e8	18.6			18.4	0%	18.5	0%
4	1e7	1.3			1.3	5%	1.3	0%
4	1e8	16.4			16.0	2%	16.2	1%
5	1e7	12.6			12.4	1%	12.4	1%
5	1e8	174.7			172.6	1%	174.9	0%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	3.7			3.6	0%	3.6	1%
0	1e8	48.4			47.7	1%	48.3	0%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	3.7			3.6	0%	3.6	1%
0	1e8	48.4			47.7	1%	48.3	0%

pandas

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	2.4			2.4	-4%	2.5	1%	1.4	62%
2	6.5			6.2	0%	6.6	-3%	3.7	71%
3	7.1			7.0	2%	7.4	0%	3.7	91%
4	3.0			2.9	1%	3.1	2%	3.2	-1%
5	7.9			7.7	0%	7.2	6%	7.1	6%
6	8.8			8.6	-3%	8.7	0%
7	6.4			6.5	-3%	6.6	-1%
8	25.8			25.6	0%	26.1	0%
9	27.2			27.2	0%	30.3	-14%	29.0	-10%
10	122.5			122.6	0%	125.9	-3%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	3.2			3.3	-3%	3.6	0%
1e8	40.3			40.1	1%	41.3	-2%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	21.8			21.7	0%	22.4	-1%
1e1	20.9			20.7	0%	20.8	0%
2e0	34.7			34.7	0%	35.0	1%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	21.8			21.7	0%	22.4	-1%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	21.8			21.7	0%	22.4	-1%
1	16.1			15.7	3%	16.3	0%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.5			0.5	-8%	0.4	8%	0.3	46%
1	1e8	4.3			4.3	-1%	4.6	-6%	2.4	78%
2	1e7	1.1			1.2	-7%	1.2	-4%	0.7	65%
2	1e8	11.8			11.2	5%	12.1	-1%	6.7	77%
3	1e7	1.0			1.0	3%	1.0	2%	0.5	87%
3	1e8	13.3			13.0	1%	13.8	-4%	6.8	94%
4	1e7	0.6			0.6	0%	0.5	10%	0.5	5%
4	1e8	5.4			5.2	4%	5.7	-5%	5.9	-8%
5	1e7	0.9			0.9	-1%	0.9	3%	0.9	-1%
5	1e8	14.9			14.5	2%	13.5	10%	13.2	13%
6	1e7	1.5			1.7	-9%	1.5	1%
6	1e8	16.0			15.6	2%	15.9	0%
7	1e7	0.9			0.9	-5%	0.9	1%
7	1e8	11.9			12.1	-2%	12.4	-4%
8	1e7	3.5			3.6	-1%	3.6	0%
8	1e8	48.0			47.5	1%	48.6	-1%
9	1e7	10.5			10.7	-1%	13.9	-24%	12.8	-17%
9	1e8	43.9			43.7	0%	46.6	-5%	45.1	-2%
10	1e7	11.7			11.7	0%	12.3	-5%
10	1e8	233.3			233.4	0%	239.4	-2%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	2.4			2.4	-4%	2.5	1%	1.4	62%
1	1e1	2.4			2.3	0%	2.3	0%	1.2	103%
1	2e0	2.0			2.0	0%	2.0	0%	1.2	77%
2	1e2	6.5			6.2	0%	6.6	-3%	3.7	71%
2	1e1	5.6			5.6	-2%	5.9	-4%	3.0	87%
2	2e0	5.0			4.8	2%	4.7	4%	3.0	62%
3	1e2	7.1			7.0	2%	7.4	0%	3.7	91%
3	1e1	20.4			19.7	2%	19.8	3%	8.6	156%
3	2e0	56.7			56.8	1%	56.8	0%	14.6	292%
4	1e2	3.0			2.9	1%	3.1	2%	3.2	-1%
4	1e1	2.9			2.9	-1%	2.9	-2%	3.3	-10%
4	2e0	2.9			2.9	0%	2.9	2%	3.4	-10%
5	1e2	7.9			7.7	0%	7.2	6%	7.1	6%
5	1e1	15.8			15.7	3%	15.4	5%	16.0	3%
5	2e0	32.0			31.9	1%	32.2	0%	32.5	0%
6	1e2	8.8			8.6	-3%	8.7	0%
6	1e1	6.3			6.2	-1%	6.2	0%
6	2e0	5.8			5.8	1%	5.5	6%
7	1e2	6.4			6.5	-3%	6.6	-1%
7	1e1	18.6			18.6	-1%	19.5	-5%
7	2e0	55.2			55.3	0%	59.9	-6%
8	1e2	25.8			25.6	0%	26.1	0%
8	1e1	32.7			32.8	-2%	32.6	0%
8	2e0	48.8			48.9	0%	48.4	1%
9	1e2	27.2			27.2	0%	30.3	-14%	29.0	-10%
9	1e1	17.0			17.0	0%	16.6	-1%	15.4	6%
9	2e0	12.9			13.2	-1%	11.9	8%	11.6	11%
10	1e2	122.5			122.6	0%	125.9	-3%
10	1e1	87.6			86.5	1%	86.7	0%
10	2e0	125.5			125.5	1%	125.3	0%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	3.2			3.3	-3%	3.6	0%
1e2	1e8	40.3			40.1	1%	41.3	-2%
1e1	1e7	2.9			2.9	-1%	3.0	-1%
1e1	1e8	38.9			38.5	0%	38.6	0%
2e0	1e7	5.2			5.1	0%	5.2	2%
2e0	1e8	64.1			64.3	0%	64.7	1%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	2.4			2.4	-4%	2.5	1%	1.4	62%
1e2	2	6.5			6.2	0%	6.6	-3%	3.7	71%
1e2	3	7.1			7.0	2%	7.4	0%	3.7	91%
1e2	4	3.0			2.9	1%	3.1	2%	3.2	-1%
1e2	5	7.9			7.7	0%	7.2	6%	7.1	6%
1e2	6	8.8			8.6	-3%	8.7	0%
1e2	7	6.4			6.5	-3%	6.6	-1%
1e2	8	25.8			25.6	0%	26.1	0%
1e2	9	27.2			27.2	0%	30.3	-14%	29.0	-10%
1e2	10	122.5			122.6	0%	125.9	-3%
1e1	1	2.4			2.3	0%	2.3	0%	1.2	103%
1e1	2	5.6			5.6	-2%	5.9	-4%	3.0	87%
1e1	3	20.4			19.7	2%	19.8	3%	8.6	156%
1e1	4	2.9			2.9	-1%	2.9	-2%	3.3	-10%
1e1	5	15.8			15.7	3%	15.4	5%	16.0	3%
1e1	6	6.3			6.2	-1%	6.2	0%
1e1	7	18.6			18.6	-1%	19.5	-5%
1e1	8	32.7			32.8	-2%	32.6	0%
1e1	9	17.0			17.0	0%	16.6	-1%	15.4	6%
1e1	10	87.6			86.5	1%	86.7	0%
2e0	1	2.0			2.0	0%	2.0	0%	1.2	77%
2e0	2	5.0			4.8	2%	4.7	4%	3.0	62%
2e0	3	56.7			56.8	1%	56.8	0%	14.6	292%
2e0	4	2.9			2.9	0%	2.9	2%	3.4	-10%
2e0	5	32.0			31.9	1%	32.2	0%	32.5	0%
2e0	6	5.8			5.8	1%	5.5	6%
2e0	7	55.2			55.3	0%	59.9	-6%
2e0	8	48.8			48.9	0%	48.4	1%
2e0	9	12.9			13.2	-1%	11.9	8%	11.6	11%
2e0	10	125.5			125.5	1%	125.3	0%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	3.2			3.3	-3%	3.6	0%
0	1e8	40.3			40.1	1%	41.3	-2%

Sortedness

by Sortedness (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	3.2			3.3	-3%	3.6	0%
0	1e8	40.3			40.1	1%	41.3	-2%
1	1e7	2.8			2.8	1%	3.2	-1%
1	1e8	29.3			28.6	4%	29.4	0%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	10.3			10.6	-1%	40.9	-70%
2	15.7			16.7	-5%	68.3	-76%
3	19.7			19.9	0%	37.4	-45%
4	29.2			30.1	-1%	59.4	-48%
5	62.4			63.2	-1%	197.9	-64%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	4.0			4.1	-1%	10.0	-57%
1e8	50.9			52.1	-3%	151.6	-64%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	27.5			28.1	-2%	80.8	-61%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	27.5			28.1	-2%	80.8	-61%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	1.6			1.6	0%	4.5	-65%
1	1e8	19.0			19.6	-3%	77.3	-75%
2	1e7	2.3			2.5	-5%	9.6	-75%
2	1e8	29.0			30.9	-6%	127.0	-77%
3	1e7	3.0			3.0	1%	5.4	-43%
3	1e8	36.3			36.9	-1%	69.5	-47%
4	1e7	4.3			4.3	0%	7.8	-45%
4	1e8	54.2			55.9	-3%	111.0	-51%
5	1e7	9.0			9.1	-1%	22.6	-60%
5	1e8	115.9			117.3	-1%	373.3	-68%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	4.0			4.1	-1%	10.0	-57%
0	1e8	50.9			52.1	-3%	151.6	-64%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	4.0			4.1	-1%	10.0	-57%
0	1e8	50.9			52.1	-3%	151.6	-64%

pydatatable

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	18.7			15.2	13%	16.1	6%	9.8	81%
2	24.6			25.9	-2%	23.5	1%	18.0	27%
3	51.5			52.7	-1%	52.0	-5%	49.3	3%
4	38.7			36.0	6%	37.3	5%	7.2	371%
5	9.6			9.3	0%	9.3	8%	8.4	0%
6	95.3			106.7	-10%	96.5	1%
7	54.1			52.7	3%	51.7	5%
8	103.3			116.6	-14%	98.3	6%
9	8.1			8.2	-4%	8.0	1%
10	338.5			356.8	-1%	330.3	8%	309.2	10%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	2.2			2.2	-4%	2.0	4%
1e8	25.8			27.4	0%	24.6	3%
1e9	194.8			204.4	0%	190.3	3%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	74.2			78.0	-1%	72.3	3%
1e1	74.2			76.4	3%	74.3	5%
2e0	122.8			126.2	0%	123.5	1%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	74.2			78.0	-1%	72.3	3%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	74.2			78.0	-1%	72.3	3%
1	56.1			61.6	-2%	55.0	1%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.4			0.4	2%	0.4	0%	0.2	80%
1	1e8	4.5			4.0	13%	4.4	1%	2.6	72%
1	1e9	51.1			41.2	23%	43.5	17%	26.7	91%
2	1e7	0.5			0.6	-7%	0.6	-3%	0.5	15%
2	1e8	7.0			6.6	6%	6.9	1%	5.5	29%
2	1e9	66.3			70.5	-6%	63.0	5%	48.1	37%
3	1e7	1.2			1.3	-3%	1.5	-15%	1.3	-2%
3	1e8	12.2			11.8	3%	12.1	0%	11.1	9%
3	1e9	141.1			145.0	-2%	142.4	0%	135.6	4%
4	1e7	1.0			0.9	11%	0.9	12%	0.3	251%
4	1e8	10.0			9.9	0%	9.9	1%	1.9	420%
4	1e9	105.2			97.3	8%	101.0	4%	19.3	444%
5	1e7	0.3			0.4	-15%	0.3	10%	0.5	-29%
5	1e8	3.8			3.4	10%	3.3	12%	3.4	10%
5	1e9	24.7			24.0	2%	24.3	1%	21.2	16%
6	1e7	1.4			1.5	-6%	1.4	4%
6	1e8	75.4			89.0	-15%	74.2	1%
6	1e9	209.1			229.6	-8%	213.9	-2%
7	1e7	1.2			1.1	7%	1.1	12%
7	1e8	11.9			12.0	0%	12.3	-2%
7	1e9	149.2			144.9	2%	141.6	5%
8	1e7	2.8			3.5	-18%	2.6	6%
8	1e8	29.3			33.6	-12%	27.3	7%
8	1e9	277.6			312.8	-11%	265.0	4%
9	1e7	0.2			0.3	-17%	0.2	0%
9	1e8	2.2			2.1	3%	2.1	3%
9	1e9	21.9			22.0	0%	21.7	1%
10	1e7	12.5			12.3	1%	11.0	13%	12.1	3%
10	1e8	101.6			101.2	0%	93.0	9%	85.6	18%
10	1e9	901.5			957.0	-5%	886.7	1%	830.0	8%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	18.7			15.2	13%	16.1	6%	9.8	81%
1	1e1	8.7			8.3	2%	8.8	-1%	4.4	81%
1	2e0	9.0			8.9	-2%	8.1	0%	4.3	77%
2	1e2	24.6			25.9	-2%	23.5	1%	18.0	27%
2	1e1	22.5			22.8	2%	21.8	-2%	9.8	100%
2	2e0	13.8			14.2	1%	13.3	2%	6.3	89%
3	1e2	51.5			52.7	-1%	52.0	-5%	49.3	3%
3	1e1	121.6			126.7	8%	121.8	9%	124.8	1%
3	2e0	325.5			335.7	0%	328.0	0%	243.5	43%
4	1e2	38.7			36.0	6%	37.3	5%	7.2	371%
4	1e1	14.3			12.7	7%	13.4	4%	3.4	279%
4	2e0	11.2			12.1	0%	12.1	0%	4.0	182%
5	1e2	9.6			9.3	0%	9.3	8%	8.4	0%
5	1e1	45.2			43.4	0%	43.9	4%	57.2	-22%
5	2e0	25.6			25.9	-6%	25.0	-1%	53.6	-58%
6	1e2	95.3			106.7	-10%	96.5	1%
6	1e1	29.6			29.5	-3%	29.2	2%
6	2e0	12.4			12.1	4%	11.9	3%
7	1e2	54.1			52.7	3%	51.7	5%
7	1e1	117.0			120.7	1%	115.2	2%
7	2e0	312.3			319.1	1%	312.8	1%
8	1e2	103.3			116.6	-14%	98.3	6%
8	1e1	43.7			42.3	8%	44.1	10%
8	2e0	27.0			27.4	-3%	27.3	2%
9	1e2	8.1			8.2	-4%	8.0	1%
9	1e1	10.3			12.2	8%	6.5	29%
9	2e0	8.3			8.5	3%	8.3	0%
10	1e2	338.5			356.8	-1%	330.3	8%	309.2	10%
10	1e1	329.3			345.3	0%	338.5	-1%	300.6	13%
10	2e0	482.8			498.5	1%	488.1	0%	286.3	77%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	2.2			2.2	-4%	2.0	4%
1e2	1e8	25.8			27.4	0%	24.6	3%
1e2	1e9	194.8			204.4	0%	190.3	3%
1e1	1e7	1.8			1.8	10%	1.9	2%
1e1	1e8	18.3			17.3	1%	17.1	6%
1e1	1e9	202.5			210.1	0%	204.0	7%
2e0	1e7	3.2			3.2	0%	3.2	0%
2e0	1e8	32.5			31.4	2%	32.1	2%
2e0	1e9	332.6			344.1	-2%	335.2	0%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	18.7			15.2	13%	16.1	6%	9.8	81%
1e2	2	24.6			25.9	-2%	23.5	1%	18.0	27%
1e2	3	51.5			52.7	-1%	52.0	-5%	49.3	3%
1e2	4	38.7			36.0	6%	37.3	5%	7.2	371%
1e2	5	9.6			9.3	0%	9.3	8%	8.4	0%
1e2	6	95.3			106.7	-10%	96.5	1%
1e2	7	54.1			52.7	3%	51.7	5%
1e2	8	103.3			116.6	-14%	98.3	6%
1e2	9	8.1			8.2	-4%	8.0	1%
1e2	10	338.5			356.8	-1%	330.3	8%	309.2	10%
1e1	1	8.7			8.3	2%	8.8	-1%	4.4	81%
1e1	2	22.5			22.8	2%	21.8	-2%	9.8	100%
1e1	3	121.6			126.7	8%	121.8	9%	124.8	1%
1e1	4	14.3			12.7	7%	13.4	4%	3.4	279%
1e1	5	45.2			43.4	0%	43.9	4%	57.2	-22%
1e1	6	29.6			29.5	-3%	29.2	2%
1e1	7	117.0			120.7	1%	115.2	2%
1e1	8	43.7			42.3	8%	44.1	10%
1e1	9	10.3			12.2	8%	6.5	29%
1e1	10	329.3			345.3	0%	338.5	-1%	300.6	13%
2e0	1	9.0			8.9	-2%	8.1	0%	4.3	77%
2e0	2	13.8			14.2	1%	13.3	2%	6.3	89%
2e0	3	325.5			335.7	0%	328.0	0%	243.5	43%
2e0	4	11.2			12.1	0%	12.1	0%	4.0	182%
2e0	5	25.6			25.9	-6%	25.0	-1%	53.6	-58%
2e0	6	12.4			12.1	4%	11.9	3%
2e0	7	312.3			319.1	1%	312.8	1%
2e0	8	27.0			27.4	-3%	27.3	2%
2e0	9	8.3			8.5	3%	8.3	0%
2e0	10	482.8			498.5	1%	488.1	0%	286.3	77%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	2.2			2.2	-4%	2.0	4%
0	1e8	25.8			27.4	0%	24.6	3%
0	1e9	194.8			204.4	0%	190.3	3%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	2.2			2.2	-4%	2.0	4%
0	1e8	25.8			27.4	0%	24.6	3%
0	1e9	194.8			204.4	0%	190.3	3%
1	1e7	1.8			2.0	0%	1.7	5%
1	1e8	20.2			24.4	-5%	20.8	-1%
1	1e9	146.2			158.5	-2%	142.3	1%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	672.7			289.6	74%	390.9	96%
2	926.9			259.6	123%	495.0	78%
3	510.2			182.8	87%	348.6	70%
4	795.1			267.4	91%	455.9	74%
5	239.7			83.5	87%	141.8	41%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	9.2			25.6	-63%	5.2	93%
1e8	329.7			135.5	146%	208.9	56%
1e9	1874.9			589.9	221%	1071.1	73%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	656.7			226.1	93%	382.5	74%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	656.7			226.1	93%	382.5	74%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	10.0			25.7	-61%	3.8	161%
1	1e8	306.3			123.8	147%	200.1	53%
1	1e9	1701.8			719.1	136%	968.8	75%
2	1e7	10.7			33.7	-68%	5.9	80%
2	1e8	388.7			179.9	116%	236.5	64%
2	1e9	2381.2			565.1	321%	1242.5	91%
3	1e7	5.5			20.1	-72%	2.6	113%
3	1e8	181.7			76.5	137%	118.2	53%
3	1e9	1343.4			451.9	197%	925.0	45%
4	1e7	10.0			18.5	-46%	4.9	102%
4	1e8	302.3			160.3	88%	214.6	40%
4	1e9	2073.0			623.4	232%	1148.3	80%
5	1e7	9.7			30.1	-67%	8.7	11%
5	1e8	469.7			136.9	243%	274.9	70%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	9.2			25.6	-63%	5.2	93%
0	1e8	329.7			135.5	146%	208.9	56%
0	1e9	1874.9			589.9	221%	1071.1	73%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	9.2			25.6	-63%	5.2	93%
0	1e8	329.7			135.5	146%	208.9	56%
0	1e9	1874.9			589.9	221%	1071.1	73%

spark

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	6.9			5.4	69%	7.6	21%	7.7	22%
2	9.6			11.7	-13%	9.9	-5%	10.3	-15%
3	29.2			28.1	-2%	28.3	-4%	27.4	-2%
4	3.5			3.5	-10%	3.5	-9%	3.6	-10%
5	23.1			23.4	-8%	21.5	-1%	23.3	-10%
7	28.6			29.7	1%	28.5	-10%
8	54.6			51.3	6%	47.4	8%
9	7.9			9.3	-13%	9.3	-13%	9.1	-11%
10	272.8			227.7	4%	230.6	0%	341.3	-9%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	1.8			2.0	-12%	2.0	-12%
1e8	8.8			8.4	24%	9.1	6%
1e9	134.9			119.7	0%	117.8	1%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	48.5			43.3	3%	43.0	-1%
1e1	48.4			45.3	0%	47.0	-3%
2e0	48.7			49.2	-10%	48.0	-5%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	48.5			43.3	3%	43.0	-1%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	48.5			43.3	3%	43.0	-1%
1	38.9			35.6	-3%	46.3	-11%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	1.6			1.7	-5%	2.1	-27%	1.6	-2%
1	1e8	6.6			2.1	214%	3.0	119%	3.3	100%
1	1e9	12.6			12.6	0%	17.6	-28%	18.1	-30%
2	1e7	1.2			2.0	-40%	1.5	-17%	2.6	-53%
2	1e8	3.9			3.3	21%	3.7	5%	3.5	11%
2	1e9	23.7			29.8	-20%	24.5	-3%	24.9	-4%
3	1e7	1.6			1.8	-9%	1.7	-6%	1.9	-14%
3	1e8	6.1			6.4	-4%	7.0	-11%	6.2	0%
3	1e9	79.9			76.1	4%	76.4	4%	74.1	7%
4	1e7	0.6			0.9	-30%	0.8	-24%	0.8	-19%
4	1e8	1.1			1.2	-7%	1.2	-7%	1.3	-13%
4	1e9	8.8			8.2	6%	8.6	2%	8.6	1%
5	1e7	1.3			1.6	-21%	1.3	-4%	1.7	-24%
5	1e8	4.5			4.7	-3%	5.0	-10%	4.8	-6%
5	1e9	63.6			64.0	0%	58.1	9%	63.3	0%
7	1e7	1.3			1.2	2%	1.6	-19%
7	1e8	5.8			5.5	5%	6.8	-14%
7	1e9	78.9			82.5	-4%	77.1	2%
8	1e7	2.5			2.5	4%	2.5	3%
8	1e8	10.7			9.7	10%	10.2	5%
8	1e9	150.5			141.6	6%	129.6	16%
9	1e7	1.1			1.3	-11%	1.2	-8%	1.3	-16%
9	1e8	2.6			3.0	-13%	3.2	-18%	2.8	-5%
9	1e9	20.0			23.7	-15%	23.4	-14%	23.2	-13%
10	1e7	4.8			4.9	-2%	5.2	-7%	5.0	-2%
10	1e8	37.3			39.5	-5%	41.6	-10%	39.2	-4%
10	1e9	776.2			638.7	21%	645.1	20%	979.8	-20%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	6.9			5.4	69%	7.6	21%	7.7	22%
1	1e1	5.3			7.4	-12%	5.2	-1%	5.1	-3%
1	2e0	5.7			6.6	-24%	5.3	11%	5.3	-2%
2	1e2	9.6			11.7	-13%	9.9	-5%	10.3	-15%
2	1e1	6.7			7.0	2%	7.2	-13%	9.1	-27%
2	2e0	6.2			6.5	-2%	5.8	-5%	5.8	-8%
3	1e2	29.2			28.1	-2%	28.3	-4%	27.4	-2%
3	1e1	36.5			35.6	5%	35.1	3%	38.1	-2%
3	2e0	49.2			51.0	-12%	52.8	-15%	79.8	-19%
4	1e2	3.5			3.5	-10%	3.5	-9%	3.6	-10%
4	1e1	3.1			3.3	1%	3.5	-16%	3.2	0%
4	2e0	3.4			3.4	-3%	3.2	-3%	3.3	-7%
5	1e2	23.1			23.4	-8%	21.5	-1%	23.3	-10%
5	1e1	31.9			27.4	20%	30.6	7%	32.1	6%
5	2e0	42.1			44.0	-11%	44.5	-13%	54.3	-21%
7	1e2	28.6			29.7	1%	28.5	-10%
7	1e1	40.1			37.9	11%	33.5	11%
7	2e0	52.8			56.6	-6%	45.6	1%
8	1e2	54.6			51.3	6%	47.4	8%
8	1e1	52.0			52.4	-1%	47.8	0%
8	2e0	54.7			63.1	-9%	49.7	0%
9	1e2	7.9			9.3	-13%	9.3	-13%	9.1	-11%
9	1e1	5.3			6.8	-24%	6.5	-19%	6.4	-13%
9	2e0	4.9			5.9	-13%	5.4	-13%	6.3	-8%
10	1e2	272.8			227.7	4%	230.6	0%	341.3	-9%
10	1e1	254.6			230.0	3%	253.3	0%	379.0	1%
10	2e0	219.1			205.2	-6%	219.9	-10%	239.8	-11%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	1.8			2.0	-12%	2.0	-12%
1e2	1e8	8.8			8.4	24%	9.1	6%
1e2	1e9	134.9			119.7	0%	117.8	1%
1e1	1e7	2.2			2.1	3%	2.2	-5%
1e1	1e8	9.5			9.3	3%	10.0	-5%
1e1	1e9	133.5			124.5	-4%	128.7	2%
2e0	1e7	1.9			2.3	-13%	2.3	-18%
2e0	1e8	9.7			11.4	-12%	11.5	-2%
2e0	1e9	134.4			133.8	-3%	130.3	4%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	6.9			5.4	69%	7.6	21%	7.7	22%
1e2	2	9.6			11.7	-13%	9.9	-5%	10.3	-15%
1e2	3	29.2			28.1	-2%	28.3	-4%	27.4	-2%
1e2	4	3.5			3.5	-10%	3.5	-9%	3.6	-10%
1e2	5	23.1			23.4	-8%	21.5	-1%	23.3	-10%
1e2	7	28.6			29.7	1%	28.5	-10%
1e2	8	54.6			51.3	6%	47.4	8%
1e2	9	7.9			9.3	-13%	9.3	-13%	9.1	-11%
1e2	10	272.8			227.7	4%	230.6	0%	341.3	-9%
1e1	1	5.3			7.4	-12%	5.2	-1%	5.1	-3%
1e1	2	6.7			7.0	2%	7.2	-13%	9.1	-27%
1e1	3	36.5			35.6	5%	35.1	3%	38.1	-2%
1e1	4	3.1			3.3	1%	3.5	-16%	3.2	0%
1e1	5	31.9			27.4	20%	30.6	7%	32.1	6%
1e1	7	40.1			37.9	11%	33.5	11%
1e1	8	52.0			52.4	-1%	47.8	0%
1e1	9	5.3			6.8	-24%	6.5	-19%	6.4	-13%
1e1	10	254.6			230.0	3%	253.3	0%	379.0	1%
2e0	1	5.7			6.6	-24%	5.3	11%	5.3	-2%
2e0	2	6.2			6.5	-2%	5.8	-5%	5.8	-8%
2e0	3	49.2			51.0	-12%	52.8	-15%	79.8	-19%
2e0	4	3.4			3.4	-3%	3.2	-3%	3.3	-7%
2e0	5	42.1			44.0	-11%	44.5	-13%	54.3	-21%
2e0	7	52.8			56.6	-6%	45.6	1%
2e0	8	54.7			63.1	-9%	49.7	0%
2e0	9	4.9			5.9	-13%	5.4	-13%	6.3	-8%
2e0	10	219.1			205.2	-6%	219.9	-10%	239.8	-11%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.8			2.0	-12%	2.0	-12%
0	1e8	8.8			8.4	24%	9.1	6%
0	1e9	134.9			119.7	0%	117.8	1%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.8			2.0	-12%	2.0	-12%
0	1e8	8.8			8.4	24%	9.1	6%
0	1e9	134.9			119.7	0%	117.8	1%
1	1e7	1.9			2.0	-6%	2.1	-10%
1	1e8	7.0			8.3	-10%	8.9	-18%
1	1e9	107.7			96.4	5%	128.0	-6%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	234.7			209.4	-3%	267.8	-17%
2	602.1			613.6	-13%	617.4	-15%
3	645.6			596.6	-7%	688.3	-14%
4	617.1			551.7	-6%
5	36.8			45.5	-14%	45.4	-14%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	5.4			5.8	-6%	6.1	-12%
1e8	37.5			50.1	-25%	51.2	-27%
1e9	1539.3			1431.3	8%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	455.1			428.9	-8%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	455.1			428.9	-8%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	4.2			4.2	0%	4.7	-12%
1	1e8	26.2			35.4	-26%	36.9	-28%
1	1e9	673.7			588.6	14%	761.8	-11%
2	1e7	3.5			4.1	-13%	4.2	-16%
2	1e8	32.3			44.6	-27%	45.8	-29%
2	1e9	1770.4			1792.1	-1%	1802.0	-1%
3	1e7	4.4			4.6	-3%	4.8	-8%
3	1e8	34.6			48.1	-28%	49.6	-30%
3	1e9	1897.8			1737.0	9%	2010.5	-5%
4	1e7	4.0			4.3	-6%	5.0	-19%
4	1e8	32.0			43.4	-26%	44.8	-28%
4	1e9	1815.3			1607.4	12%
5	1e7	11.0			12.0	-8%	11.9	-7%
5	1e8	62.6			79.0	-20%	78.9	-20%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	5.4			5.8	-6%	6.1	-12%
0	1e8	37.5			50.1	-25%	51.2	-27%
0	1e9	1539.3			1431.3	8%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	5.4			5.8	-6%	6.1	-12%
0	1e8	37.5			50.1	-25%	51.2	-27%
0	1e9	1539.3			1431.3	8%

cudf

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	0.0					0.1	-66%
2	0.0					0.1	-40%
3	0.1					1.0	-85%
4	0.1					0.3	-52%
5	0.1					0.1	-10%
6	0.5
10	0.5					0.5	3%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	0.2

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	0.2
1e1	0.2
2e0	0.2

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	0.2

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	0.2
1	0.2

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.0					0.1	-66%
2	1e7	0.0					0.1	-40%
3	1e7	0.1					1.0	-85%
4	1e7	0.1					0.3	-52%
5	1e7	0.1					0.1	-10%
6	1e7	0.5
10	1e7	0.5					0.5	3%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	0.0					0.1	-66%
1	1e1	0.0					0.0	-20%
1	2e0	0.0					0.0	-8%
2	1e2	0.0					0.1	-40%
2	1e1	0.0					0.0	17%
2	2e0	0.0					0.0	19%
3	1e2	0.1					1.0	-85%
3	1e1	0.2					0.1	44%
3	2e0	0.2					0.2	-1%
4	1e2	0.1					0.3	-52%
4	1e1	0.1					0.0	112%
4	2e0	0.1					0.1	55%
5	1e2	0.1					0.1	-10%
5	1e1	0.1					0.1	-8%
5	2e0	0.1					0.1	-6%
6	1e2	0.5
6	1e1	0.4
6	2e0	0.3
10	1e2	0.5					0.5	3%
10	1e1	0.6					0.6	3%
10	2e0	0.6					0.7	-3%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	0.2
1e1	1e7	0.2
2e0	1e7	0.2

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	0.0					0.1	-66%
1e2	2	0.0					0.1	-40%
1e2	3	0.1					1.0	-85%
1e2	4	0.1					0.3	-52%
1e2	5	0.1					0.1	-10%
1e2	6	0.5
1e2	10	0.5					0.5	3%
1e1	1	0.0					0.0	-20%
1e1	2	0.0					0.0	17%
1e1	3	0.2					0.1	44%
1e1	4	0.1					0.0	112%
1e1	5	0.1					0.1	-8%
1e1	6	0.4
1e1	10	0.6					0.6	3%
2e0	1	0.0					0.0	-8%
2e0	2	0.0					0.0	19%
2e0	3	0.2					0.2	-1%
2e0	4	0.1					0.1	55%
2e0	5	0.1					0.1	-6%
2e0	6	0.3
2e0	10	0.6					0.7	-3%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.2

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.2
1	1e7	0.2

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	0.1					0.0	103%
2	0.0					0.0	-2%
3	0.0					0.0	0%
4	0.0					0.0	0%
5	0.2					0.2	1%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	0.1					0.1	20%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	0.1					0.1	20%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	0.1					0.1	20%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.1					0.0	103%
2	1e7	0.0					0.0	-2%
3	1e7	0.0					0.0	0%
4	1e7	0.0					0.0	0%
5	1e7	0.2					0.2	1%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.1					0.1	20%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.1					0.1	20%

dask

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	352.6
2	0.8			0.9	-14%	0.8	0%	0.8	100%
3	25.6			26.1	2%	26.4	2%	71.6	-20%
4	0.9			0.8	11%	0.9	8%	1.0	99%
5	4.9			5.2	-9%	5.1	-2%	4.3	124%
7	22.7			23.3	-4%	22.2	-1%
8	212.4			251.6	-8%	220.5	-2%
10								259.0

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	6.2			6.2	0%	6.2	0%
1e8
1e9	1049.4

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2
1e1
2e0

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0
1

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.2			0.2	-6%	0.3	-34%	0.1	78%
1	1e8	8.2			7.9	4%	7.9	4%	0.6	1240%
1	1e9	1049.4
2	1e7	0.6			0.6	-5%	0.6	8%	0.2	238%
2	1e8	0.9			1.2	-23%	1.0	-8%	1.5	-36%
3	1e7	1.7			1.6	6%	1.6	7%	1.4	24%
3	1e8	49.4			50.7	-2%	51.3	-3%	141.8	-65%
4	1e7	0.7			0.5	25%	0.5	28%	0.2	242%
4	1e8	1.1			1.1	-2%	1.2	-11%	1.9	-42%
5	1e7	1.0			1.2	-15%	1.0	0%	0.3	243%
5	1e8	8.8			9.2	-4%	9.3	-4%	8.3	6%
7	1e7	1.5			1.6	-5%	1.6	-5%
7	1e8	44.0			45.0	-2%	42.7	2%
8	1e7	24.1			24.4	-1%	24.3	0%
8	1e8	400.6			478.8	-16%	416.8	-3%
10	1e7	20.0			19.7	1%	19.4	2%	14.5	38%
10	1e8								503.6

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	352.6
1	1e1	5.4			5.4	-8%	4.8	5%	0.3	907%
1	2e0	5.7			5.9	-8%	5.9	-9%	0.3	922%
2	1e2	0.8			0.9	-14%	0.8	0%	0.8	100%
2	1e1	0.5			0.6	-3%	0.5	4%	0.6	83%
2	2e0	0.5			0.6	-7%	0.6	-8%	0.6	74%
3	1e2	25.6			26.1	2%	26.4	2%	71.6	-20%
3	1e1	169.4			176.7	-3%	175.8	0%	239.8	-6%
3	2e0								395.6
4	1e2	0.9			0.8	11%	0.9	8%	1.0	99%
4	1e1	2.5			2.8	-8%	3.4	-20%	1.0	170%
4	2e0								1.1
5	1e2	4.9			5.2	-9%	5.1	-2%	4.3	124%
5	1e1	20.2			21.1	-1%	19.7	0%	15.2	69%
5	2e0								35.8
7	1e2	22.7			23.3	-4%	22.2	-1%
7	1e1	146.6			149.0	0%	170.5	-16%
7	2e0	36.2			36.8	-1%	36.1	0%
8	1e2	212.4			251.6	-8%	220.5	-2%
8	1e1	2249.9			2456.2	-4%	2270.7	0%
8	2e0	1028.6			1034.6	0%	1030.0	0%
10	1e2								259.0
10	1e1								438.8
10	2e0								621.7

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	6.2			6.2	0%	6.2	0%
1e2	1e8
1e2	1e9	1049.4
1e1	1e7	33.8			34.1	-3%	34.4	-3%
1e1	1e8
2e0	1e7	145.7			146.4	-1%	145.7	0%
2e0	1e8								339.9

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	352.6
1e2	2	0.8			0.9	-14%	0.8	0%	0.8	100%
1e2	3	25.6			26.1	2%	26.4	2%	71.6	-20%
1e2	4	0.9			0.8	11%	0.9	8%	1.0	99%
1e2	5	4.9			5.2	-9%	5.1	-2%	4.3	124%
1e2	7	22.7			23.3	-4%	22.2	-1%
1e2	8	212.4			251.6	-8%	220.5	-2%
1e2	10								259.0
1e1	1	5.4			5.4	-8%	4.8	5%	0.3	907%
1e1	2	0.5			0.6	-3%	0.5	4%	0.6	83%
1e1	3	169.4			176.7	-3%	175.8	0%	239.8	-6%
1e1	4	2.5			2.8	-8%	3.4	-20%	1.0	170%
1e1	5	20.2			21.1	-1%	19.7	0%	15.2	69%
1e1	7	146.6			149.0	0%	170.5	-16%
1e1	8	2249.9			2456.2	-4%	2270.7	0%
1e1	10								438.8
2e0	1	5.7			5.9	-8%	5.9	-9%	0.3	922%
2e0	2	0.5			0.6	-7%	0.6	-8%	0.6	74%
2e0	3								395.6
2e0	4								1.1
2e0	5								35.8
2e0	7	36.2			36.8	-1%	36.1	0%
2e0	8	1028.6			1034.6	0%	1030.0	0%
2e0	10								621.7

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	6.2			6.2	0%	6.2	0%
0	1e8
0	1e9	1049.4

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	6.2			6.2	0%	6.2	0%
0	1e8
0	1e9	1049.4
1	1e7	6.0			6.0	8%	6.0	11%
1	1e8
1	1e9	970.0					1230.6	-21%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	117.1			103.8	8%	102.6	9%
2	132.6			114.6	7%	112.6	9%
3	127.9			117.4	2%	122.0	0%
4	147.1			145.9	-1%	141.8	-1%
5	208.3			205.8	1%	211.8	-1%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	55.1			54.9	-1%	56.2	-2%
1e8	245.6			223.6	10%	222.1	11%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	139.7			129.9	3%	130.0	3%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	139.7			129.9	3%	130.0	3%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	15.7			15.3	2%	15.2	3%
1	1e8	218.5			192.2	13%	189.9	15%
2	1e7	17.0			17.4	-2%	17.2	-1%
2	1e8	248.2			211.8	17%	208.0	19%
3	1e7	15.2			15.9	-4%	16.0	-5%
3	1e8	240.6			218.9	9%	228.0	5%
4	1e7	19.2			20.2	-4%	20.9	-8%
4	1e8	275.0			271.7	1%	262.7	4%
5	1e7	208.3			205.8	1%	211.8	-1%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	55.1			54.9	-1%	56.2	-2%
0	1e8	245.6			223.6	10%	222.1	11%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	55.1			54.9	-1%	56.2	-2%
0	1e8	245.6			223.6	10%	222.1	11%

juliadf

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	11.6			12.0	0%	14.3	-13%
2	6.0			5.2	9%	4.1	20%
3	62.4			57.5	3%	58.6	0%
4	14.2			12.2	10%	14.0	5%
5	76.1			70.6	1%	77.7	-5%
6	64.1			70.2	-1%	72.2	-2%
7	152.6			149.0	0%	142.6	3%
8	144.3			151.8	-2%	153.3	-2%
9	98.2			82.4	8%	82.3	9%
10	252.2			243.7	1%	254.9	-2%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	2.0			1.9	2%	1.9	2%
1e8	13.1			13.2	1%	13.9	-3%
1e9	249.4			241.3	5%	246.4	4%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	88.2			85.5	3%	87.4	1%
1e1	11.3			11.3	-2%	11.6	0%
2e0

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	88.2			85.5	3%	87.4	1%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	88.2			85.5	3%	87.4	1%
1	73.4			74.6	0%	80.4	-1%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	6.6			6.3	5%	7.0	-5%	4.8	37%
1	1e8	7.4			7.5	-1%	8.3	-10%	6.2	19%
1	1e9	20.8			22.2	-6%	27.6	-24%
2	1e7	0.3			0.3	1%	0.3	5%	0.6	-44%
2	1e8	1.4			1.2	10%	1.3	6%	4.8	-70%
2	1e9	16.2			14.0	15%	10.8	50%
3	1e7	1.0			1.0	1%	1.1	-3%	1.1	-10%
3	1e8	4.9			4.9	0%	5.0	-2%	14.8	-66%
3	1e9	181.3			166.7	8%	169.8	6%
4	1e7	0.7			0.6	9%	0.6	13%	0.7	0%
4	1e8	3.0			2.9	5%	3.0	2%	3.8	-21%
4	1e9	38.8			33.2	16%	38.3	1%
5	1e7	0.7			0.7	-5%	0.7	-7%	1.1	-40%
5	1e8	8.9			8.8	1%	9.6	-7%	19.0	-53%
5	1e9	218.8			202.4	8%	222.8	-1%
6	1e7	2.6			2.5	3%	2.5	6%
6	1e8	15.6			15.3	1%	15.8	-1%
6	1e9	174.1			192.7	-9%	198.2	-12%
7	1e7	1.6			1.6	0%	1.5	3%
7	1e8	16.9			17.1	0%	17.3	-1%
7	1e9	439.3			428.4	2%	409.1	7%
8	1e7	1.9			1.9	0%	1.9	1%
8	1e8	23.8			24.0	0%	24.6	-3%
8	1e9	407.1			429.6	-5%	433.5	-6%
9	1e7	1.8			1.8	4%	1.7	6%	2.1	-10%
9	1e8	15.9			15.9	0%	15.9	0%	16.1	-1%
9	1e9	276.9			229.5	20%	229.4	20%
10	1e7	2.3			2.3	2%	2.2	5%	3.2	-26%
10	1e8	33.5			34.2	-2%	38.2	-12%	34.0	-1%
10	1e9	720.8			694.6	3%	724.2	0%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	11.6			12.0	0%	14.3	-13%
1	1e1	7.6			7.7	-1%	8.2	-6%	5.8	32%
1	2e0								7.5
2	1e2	6.0			5.2	9%	4.1	20%
2	1e1	0.7			0.8	-10%	0.7	-2%	1.2	-28%
2	2e0								1.1
3	1e2	62.4			57.5	3%	58.6	0%
3	1e1	9.9			9.8	0%	10.1	-1%	17.7	-39%
3	2e0								24.8
4	1e2	14.2			12.2	10%	14.0	5%
4	1e1	1.9			1.8	0%	1.9	7%	2.3	-13%
4	2e0								2.5
5	1e2	76.1			70.6	1%	77.7	-5%
5	1e1	8.2			8.1	-1%	8.5	-6%	16.4	-51%
5	2e0								21.1
6	1e2	64.1			70.2	-1%	72.2	-2%
6	1e1	6.6			6.9	-5%	6.5	3%
6	2e0	2.0			2.0	0%	1.9	4%
7	1e2	152.6			149.0	0%	142.6	3%
7	1e1	18.5			18.5	-1%	18.9	-2%
7	2e0	4.1			4.2	-1%	4.2	-1%
8	1e2	144.3			151.8	-2%	153.3	-2%
8	1e1	29.8			29.5	0%	31.6	-5%
8	2e0	9.6			9.5	1%	9.9	-3%
9	1e2	98.2			82.4	8%	82.3	9%
9	1e1	6.3			6.3	-2%	6.2	4%	6.2	-9%
9	2e0								6.7
10	1e2	252.2			243.7	1%	254.9	-2%
10	1e1	23.8			23.7	-2%	23.4	1%	25.2	-14%
10	2e0								34.5

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	2.0			1.9	2%	1.9	2%
1e2	1e8	13.1			13.2	1%	13.9	-3%
1e2	1e9	249.4			241.3	5%	246.4	4%
1e1	1e7	2.3			2.4	-4%	2.3	1%
1e1	1e8	20.3			20.2	0%	20.9	-2%
2e0	1e7	3.1			3.1	1%	3.2	1%
2e0	1e8								25.0

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	11.6			12.0	0%	14.3	-13%
1e2	2	6.0			5.2	9%	4.1	20%
1e2	3	62.4			57.5	3%	58.6	0%
1e2	4	14.2			12.2	10%	14.0	5%
1e2	5	76.1			70.6	1%	77.7	-5%
1e2	6	64.1			70.2	-1%	72.2	-2%
1e2	7	152.6			149.0	0%	142.6	3%
1e2	8	144.3			151.8	-2%	153.3	-2%
1e2	9	98.2			82.4	8%	82.3	9%
1e2	10	252.2			243.7	1%	254.9	-2%
1e1	1	7.6			7.7	-1%	8.2	-6%	5.8	32%
1e1	2	0.7			0.8	-10%	0.7	-2%	1.2	-28%
1e1	3	9.9			9.8	0%	10.1	-1%	17.7	-39%
1e1	4	1.9			1.8	0%	1.9	7%	2.3	-13%
1e1	5	8.2			8.1	-1%	8.5	-6%	16.4	-51%
1e1	6	6.6			6.9	-5%	6.5	3%
1e1	7	18.5			18.5	-1%	18.9	-2%
1e1	8	29.8			29.5	0%	31.6	-5%
1e1	9	6.3			6.3	-2%	6.2	4%	6.2	-9%
1e1	10	23.8			23.7	-2%	23.4	1%	25.2	-14%
2e0	1								7.5
2e0	2								1.1
2e0	3								24.8
2e0	4								2.5
2e0	5								21.1
2e0	6	2.0			2.0	0%	1.9	4%
2e0	7	4.1			4.2	-1%	4.2	-1%
2e0	8	9.6			9.5	1%	9.9	-3%
2e0	9								6.7
2e0	10								34.5

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	2.0			1.9	2%	1.9	2%
0	1e8	13.1			13.2	1%	13.9	-3%
0	1e9	249.4			241.3	5%	246.4	4%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	2.0			1.9	2%	1.9	2%
0	1e8	13.1			13.2	1%	13.9	-3%
0	1e9	249.4			241.3	5%	246.4	4%
1	1e7	1.9			1.9	2%	2.0	0%
1	1e8	12.1			12.7	-3%	12.6	-2%
1	1e9	206.2			209.3	0%	226.5	-3%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	231.3			232.0	-3%	230.3	-1%
2	257.8			258.4	-3%	253.1	5%
3	305.9			307.1	-3%	284.7	6%
4	263.5			265.8	-4%	259.4	5%
5	461.5			464.0	-1%	457.1	1%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	16.5			17.5	-6%	15.8	4%
1e8	591.6			593.4	0%	578.0	2%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	304.0			305.4	-3%	296.9	3%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	304.0			305.4	-3%	296.9	3%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	14.1			15.0	-5%	14.5	-2%
1	1e8	448.5			449.0	0%	446.2	0%
2	1e7	12.2			13.2	-7%	11.2	8%
2	1e8	503.4			503.7	0%	494.9	1%
3	1e7	17.2			18.5	-6%	16.2	6%
3	1e8	594.6			595.6	0%	553.2	7%
4	1e7	12.5			13.6	-8%	11.4	9%
4	1e8	514.5			518.1	0%	507.4	1%
5	1e7	26.4			27.3	-3%	25.7	2%
5	1e8	896.7			900.7	0%	888.4	0%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	16.5			17.5	-6%	15.8	4%
0	1e8	591.6			593.4	0%	578.0	2%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	16.5			17.5	-6%	15.8	4%
0	1e8	591.6			593.4	0%	578.0	2%

clickhouse

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	8.1	36.9	276%			85.1	250%	15.4	186%
2	4.5	4.5	51%			3.4	58%	7.4	38%
3	23.1	14.4	29%			7.2	72%	33.4	-22%
4	11.6	11.0	41%			17.2	33%	20.2	11%
5	6.3	5.6	15%			10.9	-3%	13.6	-21%
6	7.7	7.8	6%			15.6	-29%
7	5.6	5.9	5%			19.0	-39%
8	45.0	35.5	10%			44.4	-2%
9	34.8	34.2	39%			37.0	38%
10	503.2

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	0.5	0.3	25%			0.4	-1%
1e8	4.1	2.6	133%			3.1	126%
1e9	190.5

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	65.0
1e1	90.8
2e0	99.4

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	65.0

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	65.0
1	56.1

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.1	0.1	2%			0.1	-42%	0.1	10%
1	1e8	2.8	0.3	906%			0.3	884%	0.4	600%
1	1e9	21.5	110.4	-80%			254.9	-91%	45.8	-52%
2	1e7	0.2	0.1	7%			0.1	15%	0.1	21%
2	1e8	2.2	0.9	157%			0.9	136%	0.9	140%
2	1e9	11.0	12.5	-11%			9.0	22%	21.1	-47%
3	1e7	0.2	0.1	20%			0.2	-25%	0.2	-2%
3	1e8	1.2	1.2	4%			1.1	8%	1.8	-34%
3	1e9	68.0	42.0	62%			20.3	234%	98.1	-30%
4	1e7	0.1	0.0	87%			0.0	97%	0.0	67%
4	1e8	0.4	0.3	32%			0.3	36%	0.3	10%
4	1e9	34.3	32.6	5%			51.2	-32%	60.2	-43%
5	1e7	0.1	0.1	26%			0.1	24%	0.1	15%
5	1e8	1.1	1.1	6%			1.1	8%	1.5	-25%
5	1e9	17.7	15.6	13%			31.7	-43%	39.2	-54%
6	1e7	0.2	0.2	10%			0.5	-51%
6	1e8	1.2	1.1	12%			1.1	14%
6	1e9	21.6	22.1	-2%			45.4	-52%
7	1e7	0.2	0.2	24%			0.4	-52%
7	1e8	1.2	1.2	-3%			1.1	5%
7	1e9	15.3	16.3	-5%			55.5	-72%
8	1e7	0.8	0.8	3%			0.9	-12%
8	1e8	7.1	7.2	-1%			6.9	2%
8	1e9	127.2	98.6	28%			125.4	1%
9	1e7	0.2	0.3	-29%			0.2	-21%
9	1e8	2.5	1.0	148%			1.0	143%
9	1e9	101.8	101.2	0%			109.8	-7%
10	1e7	2.6	1.3	102%			1.7	49%
10	1e8	21.0	11.9	75%			16.9	24%
10	1e9	1486.1

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	8.1	36.9	276%			85.1	250%	15.4	186%
1	1e1	27.8	13.6	78%			14.9	70%	40.7	15%
1	2e0	15.3	1.1	604%			10.5	188%
2	1e2	4.5	4.5	51%			3.4	58%	7.4	38%
2	1e1	12.4	7.0	59%			9.1	105%	7.1	34%
2	2e0	6.1	4.3	30%			4.3	118%
3	1e2	23.1	14.4	29%			7.2	72%	33.4	-22%
3	1e1	143.3	53.0	78%			83.0	42%	47.2	73%
3	2e0	162.9	51.4	80%			69.3	30%
4	1e2	11.6	11.0	41%			17.2	33%	20.2	11%
4	1e1	12.5	24.0	20%			24.5	16%	18.6	3%
4	2e0	11.7	29.7	41%			23.1	46%
5	1e2	6.3	5.6	15%			10.9	-3%	13.6	-21%
5	1e1	46.8	14.6	135%			15.6	133%	19.3	100%
5	2e0	82.3	22.7	90%			21.9	87%
6	1e2	7.7	7.8	6%			15.6	-29%
6	1e1	7.8	14.7	1%			14.4	24%
6	2e0	11.6	16.5	-4%			5.7	74%
7	1e2	5.6	5.9	5%			19.0	-39%
7	1e1	80.3	26.0	77%			25.9	85%
7	2e0	136.3	33.9	109%			34.4	96%
8	1e2	45.0	35.5	10%			44.4	-2%
8	1e1	90.7					31.3	77%
8	2e0	123.5					33.3	107%
9	1e2	34.8	34.2	39%			37.0	38%
9	1e1	13.6					25.2	20%
9	2e0	8.7					18.5	50%
10	1e2	503.2
10	1e1	473.2
10	2e0	435.3

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	0.5	0.3	25%			0.4	-1%
1e2	1e8	4.1	2.6	133%			3.1	126%
1e2	1e9	190.5
1e1	1e7	0.4	0.3	56%			0.3	81%
1e1	1e8	4.0	2.8	34%			3.2	29%
1e1	1e9	268.1
2e0	1e7	0.5	0.4	34%			0.4	62%
2e0	1e8	4.5	3.4	47%			4.2	70%
2e0	1e9	293.2

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	8.1	36.9	276%			85.1	250%	15.4	186%
1e2	2	4.5	4.5	51%			3.4	58%	7.4	38%
1e2	3	23.1	14.4	29%			7.2	72%	33.4	-22%
1e2	4	11.6	11.0	41%			17.2	33%	20.2	11%
1e2	5	6.3	5.6	15%			10.9	-3%	13.6	-21%
1e2	6	7.7	7.8	6%			15.6	-29%
1e2	7	5.6	5.9	5%			19.0	-39%
1e2	8	45.0	35.5	10%			44.4	-2%
1e2	9	34.8	34.2	39%			37.0	38%
1e2	10	503.2
1e1	1	27.8	13.6	78%			14.9	70%	40.7	15%
1e1	2	12.4	7.0	59%			9.1	105%	7.1	34%
1e1	3	143.3	53.0	78%			83.0	42%	47.2	73%
1e1	4	12.5	24.0	20%			24.5	16%	18.6	3%
1e1	5	46.8	14.6	135%			15.6	133%	19.3	100%
1e1	6	7.8	14.7	1%			14.4	24%
1e1	7	80.3	26.0	77%			25.9	85%
1e1	8	90.7					31.3	77%
1e1	9	13.6					25.2	20%
1e1	10	473.2
2e0	1	15.3	1.1	604%			10.5	188%
2e0	2	6.1	4.3	30%			4.3	118%
2e0	3	162.9	51.4	80%			69.3	30%
2e0	4	11.7	29.7	41%			23.1	46%
2e0	5	82.3	22.7	90%			21.9	87%
2e0	6	11.6	16.5	-4%			5.7	74%
2e0	7	136.3	33.9	109%			34.4	96%
2e0	8	123.5					33.3	107%
2e0	9	8.7					18.5	50%
2e0	10	435.3

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.5	0.3	25%			0.4	-1%
0	1e8	4.1	2.6	133%			3.1	126%
0	1e9	190.5

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.5	0.3	25%			0.4	-1%
0	1e8	4.1	2.6	133%			3.1	126%
0	1e9	190.5
1	1e7	0.4	0.3	38%			0.3	49%
1	1e8	4.0	2.5	162%			2.9	196%
1	1e9	163.9

join

join for clickhouse not yet implemented.

Details

Environment

Nodename: mr-dl11

Timings

---

Report was generated on: 2020-09-09 01:56:15 PDT.